package com.soft.collateral.mapper;

import com.soft.collateral.entity.Roles;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.Set;

/**
 * <p>
 * 用户职能表 Mapper 接口
 * </p>
 *
 * @author liubin
 * @since 2025-07-25
 */
public interface RolesMapper extends BaseMapper<Roles> {

    /*@Select("select r.* " +
            "from user_role ur join roles r " +
            "on ur.role_id = r.id " +
            "where ur.user_id = #{userId}")
    public Set<Roles> selectRolesByUserId(Integer userId);

    @Select("select r.* " +
            "from role_menu rm join roles r " +
            "on rm.role_id = r.id " +
            "where rm.menu_id = #{menuId}")
    public Set<Roles> selectRolesByMenuId(Integer menuId);*/
}
